<#assign prefixName = 'WHERE'>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__beginDate??)>
	<#if (where__and__eq__beginDate__value??)>
${prefixName} T.BEGIN_DATE = :where__and__eq__beginDate__value
	<#else>
${prefixName} T.BEGIN_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__beginDate__value??)>
${prefixName} T.BEGIN_DATE <> :where__and__nq__beginDate__value
	<#else>
${prefixName} T.BEGIN_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__beginDate__value??)>
${prefixName} T.BEGIN_DATE <> :where__and__like__beginDate__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__beginDate__value??)>
${prefixName} T.BEGIN_DATE = :where__or__eq__beginDate__value
	<#else>
${prefixName} T.BEGIN_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__beginDate__value??)>
${prefixName} T.BEGIN_DATE <> :where__or__nq__beginDate__value
	<#else>
${prefixName} T.BEGIN_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__beginDate__value??)>
${prefixName} T.BEGIN_DATE <> :where__or__like__beginDate__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__endDate??)>
	<#if (where__and__eq__endDate__value??)>
${prefixName} T.END_DATE = :where__and__eq__endDate__value
	<#else>
${prefixName} T.END_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__endDate__value??)>
${prefixName} T.END_DATE <> :where__and__nq__endDate__value
	<#else>
${prefixName} T.END_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__endDate__value??)>
${prefixName} T.END_DATE <> :where__and__like__endDate__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__endDate__value??)>
${prefixName} T.END_DATE = :where__or__eq__endDate__value
	<#else>
${prefixName} T.END_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__endDate__value??)>
${prefixName} T.END_DATE <> :where__or__nq__endDate__value
	<#else>
${prefixName} T.END_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__endDate__value??)>
${prefixName} T.END_DATE <> :where__or__like__endDate__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__between__sysdate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'AND'>
</#if>
${prefixName} SYSDATE BETWEEN T.BEGIN_DATE AND T.END_DATE
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__id??)>
	<#if (where__and__eq__id__value??)>
${prefixName} T.ID = :where__and__eq__id__value
	<#else>
${prefixName} T.ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__id__value??)>
${prefixName} T.ID <> :where__and__nq__id__value
	<#else>
${prefixName} T.ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__id__value??)>
${prefixName} T.ID <> :where__and__like__id__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__id__value??)>
${prefixName} T.ID = :where__or__eq__id__value
	<#else>
${prefixName} T.ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__id__value??)>
${prefixName} T.ID <> :where__or__nq__id__value
	<#else>
${prefixName} T.ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__id__value??)>
${prefixName} T.ID <> :where__or__like__id__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__orderCode??)>
	<#if (where__and__eq__orderCode__value??)>
${prefixName} T.ORDER_CODE = :where__and__eq__orderCode__value
	<#else>
${prefixName} T.ORDER_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__orderCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__orderCode__value??)>
${prefixName} T.ORDER_CODE <> :where__and__nq__orderCode__value
	<#else>
${prefixName} T.ORDER_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__orderCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__orderCode__value??)>
${prefixName} T.ORDER_CODE <> :where__and__like__orderCode__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__orderCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__orderCode__value??)>
${prefixName} T.ORDER_CODE = :where__or__eq__orderCode__value
	<#else>
${prefixName} T.ORDER_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__orderCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__orderCode__value??)>
${prefixName} T.ORDER_CODE <> :where__or__nq__orderCode__value
	<#else>
${prefixName} T.ORDER_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__orderCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__orderCode__value??)>
${prefixName} T.ORDER_CODE <> :where__or__like__orderCode__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__permissionId??)>
	<#if (where__and__eq__permissionId__value??)>
${prefixName} T.PERMISSION_ID = :where__and__eq__permissionId__value
	<#else>
${prefixName} T.PERMISSION_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__permissionId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__permissionId__value??)>
${prefixName} T.PERMISSION_ID <> :where__and__nq__permissionId__value
	<#else>
${prefixName} T.PERMISSION_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__permissionId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__permissionId__value??)>
${prefixName} T.PERMISSION_ID <> :where__and__like__permissionId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__permissionId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__permissionId__value??)>
${prefixName} T.PERMISSION_ID = :where__or__eq__permissionId__value
	<#else>
${prefixName} T.PERMISSION_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__permissionId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__permissionId__value??)>
${prefixName} T.PERMISSION_ID <> :where__or__nq__permissionId__value
	<#else>
${prefixName} T.PERMISSION_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__permissionId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__permissionId__value??)>
${prefixName} T.PERMISSION_ID <> :where__or__like__permissionId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__validateErrorId??)>
	<#if (where__and__eq__validateErrorId__value??)>
${prefixName} T.VALIDATE_ERROR_ID = :where__and__eq__validateErrorId__value
	<#else>
${prefixName} T.VALIDATE_ERROR_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__validateErrorId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__validateErrorId__value??)>
${prefixName} T.VALIDATE_ERROR_ID <> :where__and__nq__validateErrorId__value
	<#else>
${prefixName} T.VALIDATE_ERROR_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__validateErrorId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__validateErrorId__value??)>
${prefixName} T.VALIDATE_ERROR_ID <> :where__and__like__validateErrorId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__validateErrorId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__validateErrorId__value??)>
${prefixName} T.VALIDATE_ERROR_ID = :where__or__eq__validateErrorId__value
	<#else>
${prefixName} T.VALIDATE_ERROR_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__validateErrorId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__validateErrorId__value??)>
${prefixName} T.VALIDATE_ERROR_ID <> :where__or__nq__validateErrorId__value
	<#else>
${prefixName} T.VALIDATE_ERROR_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__validateErrorId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__validateErrorId__value??)>
${prefixName} T.VALIDATE_ERROR_ID <> :where__or__like__validateErrorId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__validateRuleId??)>
	<#if (where__and__eq__validateRuleId__value??)>
${prefixName} T.VALIDATE_RULE_ID = :where__and__eq__validateRuleId__value
	<#else>
${prefixName} T.VALIDATE_RULE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__validateRuleId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__validateRuleId__value??)>
${prefixName} T.VALIDATE_RULE_ID <> :where__and__nq__validateRuleId__value
	<#else>
${prefixName} T.VALIDATE_RULE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__validateRuleId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__validateRuleId__value??)>
${prefixName} T.VALIDATE_RULE_ID <> :where__and__like__validateRuleId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__validateRuleId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__validateRuleId__value??)>
${prefixName} T.VALIDATE_RULE_ID = :where__or__eq__validateRuleId__value
	<#else>
${prefixName} T.VALIDATE_RULE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__validateRuleId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__validateRuleId__value??)>
${prefixName} T.VALIDATE_RULE_ID <> :where__or__nq__validateRuleId__value
	<#else>
${prefixName} T.VALIDATE_RULE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__validateRuleId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__validateRuleId__value??)>
${prefixName} T.VALIDATE_RULE_ID <> :where__or__like__validateRuleId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__validateSuccessId??)>
	<#if (where__and__eq__validateSuccessId__value??)>
${prefixName} T.VALIDATE_SUCCESS_ID = :where__and__eq__validateSuccessId__value
	<#else>
${prefixName} T.VALIDATE_SUCCESS_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__validateSuccessId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__validateSuccessId__value??)>
${prefixName} T.VALIDATE_SUCCESS_ID <> :where__and__nq__validateSuccessId__value
	<#else>
${prefixName} T.VALIDATE_SUCCESS_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__validateSuccessId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__validateSuccessId__value??)>
${prefixName} T.VALIDATE_SUCCESS_ID <> :where__and__like__validateSuccessId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__validateSuccessId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__validateSuccessId__value??)>
${prefixName} T.VALIDATE_SUCCESS_ID = :where__or__eq__validateSuccessId__value
	<#else>
${prefixName} T.VALIDATE_SUCCESS_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__validateSuccessId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__validateSuccessId__value??)>
${prefixName} T.VALIDATE_SUCCESS_ID <> :where__or__nq__validateSuccessId__value
	<#else>
${prefixName} T.VALIDATE_SUCCESS_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__validateSuccessId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__validateSuccessId__value??)>
${prefixName} T.VALIDATE_SUCCESS_ID <> :where__or__like__validateSuccessId__value
	</#if>
	<#assign prefixName = ''>
</#if>
